Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Previous Next

any of those sounds reasonable

Some of it depends on whether the user needs to enter any more information. If you can tell enough from a forwarded email to create your SQL record without further user input, then forward to a mail-in database is very easy for the user. Otherwise, you might just add an action to the mail template (it could be an agent) to process selected documents or the current document that's open, using a dialogbox to prompt the user for any extra information you might need. You might also flag the documents so processed to avoid processing them a second time.

If the users all have the SQL drivers installed, you can program writing the actual data with the LC LSX. If you don't want to mess with that, or want to be able to do this work offline, you can still use a mail-in database but instead of forwarding documents, mail a document containing items corresponding to the database fields, or XML data in a rich text field (for multiple records at once) or similar. Remember that you can put any items, with any names and datatypes, into a document you mail. It doesn't have to contain only the same fields as a memo.


Feedback response number AGUD8RBKVD created by ~Julia Prefootherlen on 02/09/2012

Creating SQL database records relat... (~Denise Chutoog... 9.Feb.12)
. . any of those sounds reasonable (~Bill Frokimari... 9.Feb.12)
. . . . user input is required (~Denise Chutoog... 10.Feb.12)
. . . . . . The mail database is very complicat... (~Bill Frokimari... 15.Feb.12)




Printer-friendly

Search this forum

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS